﻿CREATE TABLE [dbo].[WayBill] (
    [Id]                   UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [RefNumber]            NVARCHAR (50)    NOT NULL,
    [IssuingOffice]        NVARCHAR (250)   NOT NULL,
    [IssuerWarehouse]      NVARCHAR (250)   NULL,
    [DestinationOffice]    NVARCHAR (250)   NOT NULL,
    [DestinationWarehouse] NVARCHAR (250)   NULL,
    [LoadingDate]          DATE             NULL,
    [DispatchDate]         DATE             NULL,
    [Consignee]            NVARCHAR (250)   NULL,
    [ConsigneeContact]     NVARCHAR (50)    NULL,
    [WarehouseReleaseId]   UNIQUEIDENTIFIER NULL,
    [DRCVehicleRegNo]      NVARCHAR (50)    NULL,
    [DRCVehicleMileage]    FLOAT            NULL,
    [DRCVehicleContactNo]  NVARCHAR (50)    NULL,
    [LoadingRemarks]       NTEXT            NULL,
    [CountryProgrammeId]   UNIQUEIDENTIFIER NULL
);

